Extension point org.nuxeo.ecm.platform.query.api.PageProviderService--providers

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

      <coreQueryPageProvider name="DEFAULT_DOCUMENT_SUGGESTION">
        <property name="maxResults">PAGE_SIZE</property>
        <pattern escapeParameters="true" quoteParameters="false">
          SELECT * FROM Document WHERE ecm:fulltext.dc:title LIKE '?' AND ecm:mixinType !=
          'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
          ecm:currentLifeCycleState != 'deleted'
        </pattern>
        <pageSize>10</pageSize>
      </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-suggestbox-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <documentation>
      This contribution declares page providers used by UI components.

      The page provider 'tree_children' is used to list children in the tree
      navigation.

      Note the "ecm:isProxy = 0" predicate optimization that is required to
      simplify greatly the request performed by the tree manager when browsing
      on folders with a lot of files when using the Visible SQL Storage.

      The page provider 'default_document_suggestion' is used by default by the
      component performing document suggestions.
    </documentation>

    <coreQueryPageProvider name="tree_children">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isProxy = 0 AND
        ecm:mixinType = 'Folderish' AND ecm:mixinType != 'HiddenInNavigation'
        AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
        'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="default_document_suggestion">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern escapeParameters="true" quoteParameters="false">
        SELECT * FROM Document WHERE ecm:fulltext LIKE '?*' AND ecm:mixinType !=
        'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
        ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <!-- sort column="dc:title" ascending="true" / sort by fulltext relevance -->
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-webapp-base-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
        <coreQueryPageProvider name="REST_API_SEARCH_ADAPTER">
            <pageSize>0</pageSize>
            <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    </extension>

(?) nuxeo-rest-api-server-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="FOLDER_ITEM_CHILDREN">
      <pattern>
        SELECT * FROM Document WHERE ecm:parentId = ?
        AND ecm:isCheckedInVersion = 0
        AND ecm:isProxy = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND ecm:mixinType != 'HiddenInNavigation'
      </pattern>
      <sort ascending="true" column="dc:created"/>
      <pageSize>1000</pageSize>
      <maxPageSize>1000</maxPageSize>
      <property name="maxResults">PAGE_SIZE</property>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-drive-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ALL_ROUTE_MODELS">
      <pattern>
        SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState =
        'validated' AND dc:title LIKE ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>20</pageSize>
    </coreQueryPageProvider>
    
    <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ALL_ROUTE_INSTANCES">
      <pattern>
        SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState =
        'running' AND dc:title LIKE ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="CURRENT_DOC_ROUTING_SEARCH_ATTACHED_DOC">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType != 'Folderish' AND
        ecm:currentLifeCycleState != 'deleted' AND dc:title ILIKE ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="SEARCH_ROUTE_BY_ATTACHED_DOC">
      <pattern>
        SELECT * FROM DocumentRoute WHERE (ecm:currentLifeCycleState = 'running'
        OR ecm:currentLifeCycleState = 'ready') AND docri:participatingDocuments
        IN (?)
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>20</pageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-routing-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

      <coreQueryPageProvider name="search_core_default">
        <property name="coreSession">#{documentManager}</property>
        <whereClause docType="DefaultSearch">
          <fixedPart>
            ecm:mixinType != 'HiddenInNavigation' AND ecm:isProxy = 0
            AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
            AND SORTED_COLUMN IS NOT NULL
          </fixedPart>
          <predicate operator="FULLTEXT" parameter="ecm:fulltext">
            <field name="ecm_fulltext" schema="default_search"/>
          </predicate>
          <predicate operator="IN" parameter="dc:creator">
            <field name="dc_creator" schema="default_search"/>
          </predicate>
          <predicate operator="BETWEEN" parameter="dc:created">
            <field name="dc_created_min" schema="default_search"/>
            <field name="dc_created_max" schema="default_search"/>
          </predicate>
          <predicate operator="STARTSWITH" parameter="dc:subjects">
            <field name="dc_subjects" schema="default_search"/>
          </predicate>
          <predicate operator="STARTSWITH" parameter="dc:coverage">
            <field name="dc_coverage" schema="default_search"/>
          </predicate>
          <predicate operator="STARTSWITH" parameter="ecm:path">
            <field name="ecm_path" schema="default_search"/>
          </predicate>
          <predicate operator="IN" parameter="collectionMember:collectionIds">
            <field name="ecm_collections" schema="default_search"/>
          </predicate>
        </whereClause>
        <sort ascending="true" column="dc:title"/>
        <pageSize>20</pageSize>
      </coreQueryPageProvider>

  </extension>

(?) nuxeo-web-mobile-cap-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="search_media_all">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:primaryType = ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>100</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="search_media_by_title">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:primaryType = ?
        AND ecm:fulltext LIKE ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>100</pageSize>
    </coreQueryPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.webapp.provider.ImportFolderPageProvider" name="importFolders">
      <pattern escapeParameters="true" quoteParameters="false">
        SELECT * FROM Document WHERE ecm:fulltext.dc:title LIKE '?' AND ecm:mixinType !=
        'HiddenInNavigation' AND ecm:mixinType = 'Folderish'
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>10</pageSize>
    </genericPageProvider>

  </extension>

(?) nuxeo-platform-webapp-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="GET_FORUM_MODERATION_TASKS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:targetDocumentId = ? AND nt:task_variables/*/key = 'commentId' AND
        nt:task_variables/*/value = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-forum-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.UsersPageProvider" name="users_listing">
      <pageSize>20</pageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.NuxeoPrincipalsPageProvider" name="nuxeo_principals_listing">
      <pageSize>20</pageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.GroupsPageProvider" name="groups_listing">
      <pageSize>20</pageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.NuxeoGroupsPageProvider" name="nuxeo_groups_listing">
      <pageSize>20</pageSize>
    </genericPageProvider>

  </extension>

(?) nuxeo-platform-usermanager-api-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="DEFAULT_CREATION_CONTAINER_LIST_PROVIDER">
      <pattern>
        SELECT * FROM Document WHERE ecm:primaryType IN ('Workspace',
        'Folder') AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="ecm:path"/>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-filemanager-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    <coreQueryPageProvider name="domains_for_publishing">
      <pattern>
        SELECT * FROM Document WHERE ecm:primaryType = 'Domain'
        AND ecm:parentId = ? AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>
  </extension>

(?) nuxeo-platform-publisher-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
   
    <coreQueryPageProvider name="default_section_suggestion">
      <pattern escapeParameters="true" quoteParameters="false">
        SELECT * FROM Section WHERE dc:title LIKE '?%' AND ecm:mixinType !=
        'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
        ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <!-- sort column="dc:title" ascending="true" / sort by fulltext relevance -->
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-routing-dm-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.AuditPageProvider" name="AUDIT_BROWSER">
      <whereClause docType="BasicAuditSearch">
        <predicate operator=">" parameter="log.id">
          <field name="logId" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="BETWEEN" parameter="log.eventDate">
          <field name="startDate" schema="basicauditsearch"/>
          <field name="endDate" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.category">
          <field name="eventCategories" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.eventId">
          <field name="eventIds" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.principalName">
          <field name="principalNames" schema="basicauditsearch"/>
        </predicate>
      </whereClause>
      <sort ascending="true" column="log.eventDate"/>
      <sort ascending="true" column="log.id"/>
      <pageSize>10</pageSize>
    </genericPageProvider>

  </extension>

(?) nuxeo-automation-features-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    <coreQueryPageProvider name="CURRENT_DOC_CHILDREN">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:parentId = ? AND
        ecm:mixinType != 'HiddenInNavigation'
        AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
        'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>
  </extension>

(?) nuxeo-automation-server-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

      <coreQueryPageProvider name="USER_SAVED_SEARCHES">
        <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
        <pattern>
          SELECT * FROM FacetedSearch WHERE dc:creator = ? AND
          ecm:currentLifeCycleState != 'deleted'
        </pattern>
        <sort ascending="true" column="dc:title"/>
      </coreQueryPageProvider>

      <coreQueryPageProvider name="OTHER_USERS_SAVED_SEARCHES">
        <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
        <pattern>
          SELECT * FROM FacetedSearch WHERE dc:creator != ? AND
          ecm:currentLifeCycleState != 'deleted'
        </pattern>
        <sort ascending="true" column="dc:title"/>
      </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-faceted-search-jsf-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="SAVED_SEARCHES">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND dc:creator = ? AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="SHARED_SAVED_SEARCHES">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND dc:creator != ? AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-search-ui-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="user_domains">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Domain WHERE ecm:mixinType != 'HiddenInNavigation'
        AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>0</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="domain_documents">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:path STARTSWITH ?
        AND ecm:mixinType != 'Folderish' AND ecm:mixinType !=
        'SystemDocument' AND ecm:mixinType !=
        'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:isProxy = 0
        AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="false" column="dc:modified"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="domain_published_documents">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:path STARTSWITH ? AND ecm:mixinType !=
        'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:mixinType != 'SystemDocument' AND
        ecm:isCheckedInVersion = 0 AND ecm:isProxy = 1
      </pattern>
      <sort ascending="true" column="dc:modified"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="user_documents">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE dc:contributors = ? AND ecm:mixinType !=
        'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:mixinType != 'SystemDocument' AND
        ecm:isCheckedInVersion = 0 AND ecm:isProxy = 0 AND
        ecm:currentLifeCycleState != 'deleted' AND ecm:path STARTSWITH ?
      </pattern>
      <sort ascending="true" column="dc:modified"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="user_sections">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:primaryType = 'Section' AND
        ecm:mixinType != 'HiddenInNavigation' AND ecm:path STARTSWITH ?
      </pattern>
      <sort ascending="true" column="dc:modified"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="user_sites">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'WebView' AND
        ecm:currentLifeCycleState != 'deleted' AND webc:isWebContainer = 1 AND
        ecm:path STARTSWITH ?
      </pattern>
      <sort ascending="true" column="webc:name"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="user_workspaces">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Workspace WHERE ecm:mixinType != 'HiddenInNavigation' AND
        ecm:currentLifeCycleState != 'deleted' AND ecm:isProxy = 0 AND ecm:path
        STARTSWITH ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="user_deleted_documents">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE dc:contributors = ? AND ecm:mixinType !=
        'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:mixinType != 'SystemDocument' AND
        ecm:isCheckedInVersion = 0 AND ecm:isProxy = 0 AND
        ecm:currentLifeCycleState = 'deleted'
      </pattern>
      <sort ascending="true" column="dc:modified"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="user_favorites">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
        'deleted' AND collectionMember:collectionIds/* = ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>5</pageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-user-dashboard-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_DOCUMENT_IDS_FOR_TAG">
      <property name="useUnrestrictedSession">true</property>
      <pattern>
        SELECT ecm:uuid FROM Tag WHERE tag:label = ? AND ecm:isProxy = 0
      </pattern>
      <pageSize>1</pageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_FIRST_TAGGING_FOR_DOC_AND_TAG">
      <property name="useUnrestrictedSession">true</property>
      <pattern>
        SELECT ecm:uuid FROM Tagging WHERE relation:source = ? AND
        relation:target = ?
      </pattern>
      <pageSize>1</pageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_FIRST_TAGGING_FOR_DOC_AND_TAG_AND_USER">
      <property name="useUnrestrictedSession">true</property>
      <pattern>
        SELECT ecm:uuid FROM Tagging WHERE relation:source = ? AND
        relation:target = ? AND dc:creator = ?
      </pattern>
      <pageSize>1</pageSize>
    </genericPageProvider>

    <!-- page provider that can be optimized using ES for instance -->
    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
        relation:source = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <!-- page provider that should keep on using the VCS storage -->
    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT_CORE">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
        relation:source = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_DOCUMENTS_FOR_TAG">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT DISTINCT relation:source FROM Tagging WHERE
        tag:label = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <!-- page provider that can be optimized using ES for instance -->
    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT_AND_USER">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
        relation:source = ? AND dc:creator = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <!-- page provider that should keep on using the VCS storage -->
    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT_AND_USER_CORE">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
        relation:source = ? AND dc:creator = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_DOCUMENTS_FOR_TAG_AND_USER">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT DISTINCT relation:source FROM Tagging WHERE
        tag:label = ? AND dc:creator = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_TO_COPY_FOR_DOCUMENT">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        TAGISTARGET: SELECT tag:label, dc:created, dc:creator,
        relation:target FROM Tagging
        WHERE relation:source = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAG_SUGGESTIONS">
      <property name="useUnrestrictedSession">true</property>
      <pattern>
        SELECT DISTINCT tag:label FROM Tag WHERE tag:label LIKE ? AND
        ecm:isProxy = 0
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAG_SUGGESTIONS_FOR_USER">
      <property name="useUnrestrictedSession">true</property>
      <pattern>
        SELECT DISTINCT tag:label FROM Tag WHERE tag:label LIKE ? AND
        ecm:isProxy = 0
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_ALL_TAGS">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_ALL_TAGS_FOR_USER">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging WHERE
        dc:creator = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENTS">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging WHERE
        relation:source IN ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENTS_AND_USER">
      <property name="useUnrestrictedSession">true</property>
      <property name="language">NXTAG</property>
      <pattern>
        COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging WHERE
        relation:source IN ? AND dc:creator = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGGED_DOCUMENTS_UNDER">
      <property name="useUnrestrictedSession">true</property>
      <pattern>
        SELECT ecm:uuid FROM Document WHERE ecm:path STARTSWITH ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </genericPageProvider>

  </extension>

(?) nuxeo-platform-tag-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="GET_COMMENT_MODERATION_TASKS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:targetDocumentId = ? AND nt:actors IN (?) AND
        nt:task_variables/*/key = 'commentId' AND nt:task_variables/*/value = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-comment-workflow-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="default_collection">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document WHERE dc:title ILIKE ? AND ecm:mixinType = 'Collection' AND
        (ecm:primaryType != 'Favorites' OR (ecm:primaryType = 'Favorites' AND dc:creator = ?)) AND
        ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <parameter>#{currentUser.name}</parameter>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="default_collection_candidate">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document where dc:title ILIKE ? AND ecm:isProxy = 0
        AND ecm:mixinType != 'SystemDocument' AND ecm:mixinType !=
        'NotCollectionMember' AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="default_content_collection">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
        'deleted' AND collectionMember:collectionIds/* = ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="all_collections">
      <property name="maxResults">PAGE_SIZE</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Collection' AND
        ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <pageSize>1000</pageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-collections-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    <coreQueryPageProvider name="spreadsheet_query">
      <property name="maxResults">1000</property>
      <pattern escapeParameters="false" quoteParameters="false">?</pattern>
      <pageSize>1000</pageSize>
    </coreQueryPageProvider>
  </extension>

(?) nuxeo-platform-spreadsheet-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.task.providers.UserTaskPageProvider" name="user_tasks">
      <property name="locale">#{localeSelector.localeString}</property>
      <pageSize>20</pageSize>
      <sort ascending="true" column="nt:dueDate"/>
    </genericPageProvider>

  </extension>

(?) nuxeo-platform-task-automation-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="GET_TASKS_FOR_ACTORS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:actors IN ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENT">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:targetDocumentId = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENT_AND_ACTORS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:targetDocumentId = ? AND nt:actors IN ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENTS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds IN (?))
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENTS_AND_ACTORS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds IN (?)) AND
        nt:actors IN ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_PROCESS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:processId = ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_PROCESS_AND_ACTORS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:processId = ? AND nt:actors IN ?
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_PROCESS_AND_NODE">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND nt:processId = ? AND nt:task_variables/*/key = 'nodeId' AND
        nt:task_variables/*/value = ?";
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENTS_AND_ACTORS_OR_DELEGATED_ACTORS">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
        ecm:currentLifeCycleState
        NOT IN ('ended', 'cancelled') AND ecm:isProxy =
        0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds IN (?)) AND
        (nt:actors IN ? OR nt:delegatedActors IN ?)";
      </pattern>
      <pageSize>0</pageSize>
      <maxPageSize>0</maxPageSize>
    </coreQueryPageProvider>

  </extension>

(?) nuxeo-platform-task-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.AuditPageProvider" name="DOCUMENT_HISTORY_PROVIDER_OLD">
      <whereClause docType="BasicAuditSearch">
        <fixedPart>
          log.docUUID = ?
        </fixedPart>
        <predicate operator="BETWEEN" parameter="log.eventDate">
          <field name="startDate" schema="basicauditsearch"/>
          <field name="endDate" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.category">
          <field name="eventCategories" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="=" parameter="log.eventId">
          <field name="eventId" schema="basicauditsearch"/>
        </predicate>
      </whereClause>
      <sort ascending="true" column="log.eventDate"/>
      <pageSize>10</pageSize>
    </genericPageProvider>

    <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.document.DocumentHistoryPageProvider" name="DOCUMENT_HISTORY_PROVIDER">
      <whereClause docType="BasicAuditSearch">
        <predicate operator="BETWEEN" parameter="log.eventDate">
          <field name="startDate" schema="basicauditsearch"/>
          <field name="endDate" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="=" parameter="log.category">
          <field name="eventCategory" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.category">
          <field name="eventCategories" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="=" parameter="log.eventId">
          <field name="eventId" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.eventId">
          <field name="eventIds" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="=" parameter="log.principalName">
          <field name="principalName" schema="basicauditsearch"/>
        </predicate>
        <predicate operator="IN" parameter="log.principalName">
          <field name="principalNames" schema="basicauditsearch"/>
        </predicate>
      </whereClause>
      <sort ascending="false" column="log.eventDate"/>
      <sort ascending="false" column="log.id"/>
      <pageSize>10</pageSize>
      <maxPageSize>1000</maxPageSize>
    </genericPageProvider>

  </extension>

(?) nuxeo-platform-audit-core-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.shibboleth.ShibbolethGroupsPageProvider" name="shibb_groups_listing">
      <pageSize>20</pageSize>
    </genericPageProvider>

  </extension>

(?) nuxeo-platform-login-shibboleth-6.0.jar Override

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.AuditPageProvider" name="EVENTS_VIEW">
        <whereClause docType="BasicAuditSearch">
          <predicate operator="BETWEEN" parameter="log.eventDate">
            <field name="startDate" schema="basicauditsearch"/>
            <field name="endDate" schema="basicauditsearch"/>
          </predicate>
          <predicate operator="=" parameter="log.category">
            <field name="eventCategory" schema="basicauditsearch"/>
          </predicate>
          <predicate operator="IN" parameter="log.eventId">
            <field name="eventIds" schema="basicauditsearch"/>
          </predicate>
          <predicate operator="=" parameter="log.principalName">
            <field name="principalName" schema="basicauditsearch"/>
          </predicate>
        </whereClause>
        <sort ascending="false" column="log.eventDate"/>
        <pageSize>10</pageSize>
        <maxPageSize>1000</maxPageSize>
      </genericPageProvider>

  </extension>

(?) nuxeo-admin-center-6.0.jar Override

Extension point providers

Contribution Descriptors

Existing Contributions